SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwllacumuladas
AS
SELECT     Licencia AS ID, Documento, Nombres, Descripcion, SUM(dias) + 1 AS Dias, Agente
FROM         dbo.vw_cantidaddiaslicencia
GROUP BY Licencia, Documento, Nombres, Descripcion, Agente
GO
GRANT SELECT ON  [dbo].[vwllacumuladas] TO [PersonalDocente]
GRANT SELECT ON  [dbo].[vwllacumuladas] TO [SoloVer]
GO
